An Algorithm for Automatic Inference of Referential Integrities During Translation from Relational Database to XML Schema
نویسندگان
چکیده
XML is rapidly becoming one of the most widely adopted technologies for information exchange and representation on the World Wide Web. However, the large part of data is still stored in a relational database and we need to convert those relational data into an XML document. There are existing approaches such as NeT and CoT to convert relational models to XML models but those approaches only consider explicit referential integrities. In this paper, we suggest an algorithm to reflect implicit referential integrities to the conversion. The proposed algorithm provides several good points such as improving semantic information extraction and conversion, securing sufficient referential integrity of the target databases, and so on.
منابع مشابه
Query Pattern-based Relational Data to XML Data Translation Algorithm
This paper proposes a new query pattern-based relational schema-to-XML schema translation (QP-T) algorithm to resolve implicit referential integrity issue. Various translation methods have been introduced on structural aspects and/or semantic aspects. However, most of conventional methods consider only explicit referential integrities specified by relational schema. It causes several problems s...
متن کاملA Translation Algorithm for Effective RDB-to-XML Schema Conversion Considering Referential Integrity Information
In this paper, we propose a new relational schema (R-schema) to XML Schema translation algorithm that analyzes the cardinality between data values and patterns of user queries to resolve the implicit referential integrity issue. Many translation methods have been developed taking into account structural and/or semantic aspects. However, earlier methods have considered only the explicit referent...
متن کاملNeT & CoT: Inferring XML Schemas from Relational World
With XML emerging as the data format of the Internet era, there is a substantial increase in the amount of data encoded in XML. However, the majority of everyday data is still stored and maintained in relational databases. Therefore, we expect the needs to convert such relational data into XML documents will grow substantially as well. Two conversion algorithms, called NeT and CoT, to translate...
متن کاملEffective Schema Conversions between XML and Relational Models
As Extensible Markup Language (XML) is emerging as the data format of the Internet era, there is an increasing need to efficiently store and query XML data. At the same time, as requirements change, we expect a substantial amount of conventional relational data to be converted or published as XML data. One path to accommodate these changes is to transform XML data into relational format (and vi...
متن کاملOptimizing Fixed-Schema XML to SQL Query Translation
Recently, there has been a lot of work on evaluating XML queries over data stored in relational database systems. The vast majority of this work has focused on the cases where either the relational schema is not fixed (so the problem is to find a good relational schema for a given XML workload) or the XML schema is not fixed (so the problem is to develop generic strategies for exporting XML vie...
متن کامل